Skip Headers

Oracle® OLAP Reference 10g Release 2 (10.2) Part Number B14350-01 |
Home | Book List | Contents | Master Index | Feedback

Previous
| View PDF

# Index

A C D E F G H I J L M O P Q R S T U V W X Y

## A

  abstract data types, 34.1.2
    automatic, 34.1.4
    predefining, 34.1.3
  Active Catalog, 1.1.6.1, 3, 3.2, 19.2, 34.1
    direct metadata access, 3.6, 3.7, 3.13, 3.14
  ADD_DIMENSION_SOURCE procedure, 24.4.2
  ADT
    See abstract data types
  ADVISE_CUBE procedure, 24.4.2, 24.4.2
  ADVISE_DIMENSIONALITY function, 24.4.2
  ADVISE_DIMENSIONALITY procedure, 24.4.2
  ADVISE_REL procedure, 24.4.2, 24.4.2
  ADVISE_SPARSITY procedure, 24.4.2
  Aggregate Advisor, 24.4
  aggregate cache
    performance statistics, 6.5
  aggregation
    in analytic workspaces, 1.1.4, 1.6, 24.4, 26.1, 26.1
    operators, 1.6, 5.5, 6.3
  aggregation specifications, 1.1.4, 1.2, 1.3, 1.4, 3.11
    creating, 1.6, 26.1
    DBMS_AWM methods on, 1.2.5
  ALL_AW_CUBE_AGG_LEVELS view, 4.4
  ALL_AW_CUBE_AGG_MEASURES view, 4.5
  ALL_AW_CUBE_AGG_PLANS view, 4.6
  ALL_AW_CUBE_ENABLED_HIERCOMBO view, 4.7
  ALL_AW_CUBE_ENABLED_VIEWS view, 4.8
  ALL_AW_DIM_ENABLED_VIEWS view, 4.9
  ALL_AW_LOAD_CUBE_DIMS view, 4.11
  ALL_AW_LOAD_CUBE_FILTS view, 4.12
  ALL_AW_LOAD_CUBE_MEASURES view, 4.13
  ALL_AW_LOAD_CUBE_PARMS view, 4.14
  ALL_AW_LOAD_CUBES view, 4.10
  ALL_AW_LOAD_DIM_FILTERS view, 4.16
  ALL_AW_LOAD_DIM_PARMS view, 4.17
  ALL_AW_LOAD_DIMENSIONS view, 4.15
  ALL_AW_OBJ view, 4.18
  ALL_AW_PROP view, 4.19
  ALL_OLAP2_AGGREGATION_USES view, 5.5
  ALL_OLAP2_AW_ATTRIBUTES view, 3.6
  ALL_OLAP2_AW_CUBE_AGG_LVL view, 3.8
  ALL_OLAP2_AW_CUBE_AGG_MEAS view, 3.9
  ALL_OLAP2_AW_CUBE_AGG_OP view, 3.10
  ALL_OLAP2_AW_CUBE_AGG_SPECS view, 3.11
  ALL_OLAP2_AW_CUBE_DIM_USES view, 3.12
  ALL_OLAP2_AW_CUBE_MEASURES view, 3.13
  ALL_OLAP2_AW_CUBES view, 3.7
  ALL_OLAP2_AW_DIM_HIER_LVL_ORD view, 3.15
  ALL_OLAP2_AW_DIM_LEVELS view, 3.16
  ALL_OLAP2_AW_DIMENSIONS view, 3.14
  ALL_OLAP2_AW_MAP_ATTR_USE view (obsolete)
    See ALL_OLAP2_AW_ATTRIBUTES view
  ALL_OLAP2_AW_MAP_DIM_USE view (obsolete)
    See ALL_OLAP2_AW_DIMENSIONS view
  ALL_OLAP2_AW_MAP_MEAS_USE view (obsolete)
    See ALL_OLAP2_AW_CUBE_MEASURES view
  ALL_OLAP2_AW_PHYS_OBJ_PROP view, 3.18
  ALL_OLAP2_AWS view, 3.5
  ALL_OLAP2_CATALOG_ENTITY_USES view, 5.7
  ALL_OLAP2_CATALOGS view, 5.6
  ALL_OLAP2_CUBE_DIM_USES view, 5.9
  ALL_OLAP2_CUBE_MEAS_DIM_USES view, 5.12
  ALL_OLAP2_CUBE_MEASURE_MAPS view, 5.11
  ALL_OLAP2_CUBE_MEASURES view, 5.10
  ALL_OLAP2_CUBES view, 5.8
  ALL_OLAP2_DIM_ATTR_USES view, 5.15
  ALL_OLAP2_DIM_ATTRIBUTES view, 5.14
  ALL_OLAP2_DIM_HIER_LEVEL_USES view, 5.17
  ALL_OLAP2_DIM_HIERARCHIES view, 5.16
  ALL_OLAP2_DIM_LEVEL_ATTR_MAPS view, 5.20
  ALL_OLAP2_DIM_LEVEL_ATTRIBUTES view, 5.19
  ALL_OLAP2_DIM_LEVELS view, 5.18
  ALL_OLAP2_DIMENSIONS view, 5.13
  ALL_OLAP2_ENTITY_EXT_PARMS view, 5.22
  ALL_OLAP2_ENTITY_PARAMETERS view, 5.23
  ALL_OLAP2_FACT_LEVEL_USES view, 5.24
  ALL_OLAP2_FACT_TABLE_GID view, 5.25
  ALL_OLAP2_HIER_CUSTOM_SORT view, 5.26
  ALL_OLAP2_JOIN_KEY_COLUMN_USES view, 5.27
  allocation operators, 6.4
  ALTER SESSION commands, 28.1
  analytic workspace maintenance views, 1.1.6.2, 4
  analytic workspace management APIs, 25.1, 26
  Analytic Workspace Manager, 1, 1.8.3, 26, 34.1
  analytic workspace objects
    defining in XML, 25.1
    obtaining names in SQL, 4.18
  analytic workspaces
    accessing from SQL, 24
    Active Catalog, 3
    aggregation, 1.1.4, 1.6, 24.4, 26.1, 26.1
    converting to 10g storage format, 1.7, 3.5, 3.5, 24.1.1
    creating with DBMS_AWM, 1.3
    creating with OLAP Analytic Workspace Java API, 25.1
    creating with XML, 25.1
    dimensions, 1.5
    enabling for SQL access, 26, 26.1, 26.1, 26.1, 26.1, 26.1, 26.1, 26.1, 26.1, 26.1, 26.1
    enabling for the OLAP API, 1.7
    importing from Oracle 9i, 24.1.1.1
    list of, 3.5
    maintenance views, 4
    performance counters, 6.7
    refreshing, 1.2.1, 1.2.2, 1.3, 1.3, 1.4, 1.4, 1.6, 1.8.5, 1.8.5, 1.8.6, 1.8.6, 26.1, 26.1
    see also database standard form
    storage format, 1.7, 3.5, 24.1.1
    views of, 1.8.5, 1.8.6, 26.1, 26.1, 26.1, 26.1
  attributes
    viewing, 5.15
  AW_ATTACH procedure, 24.4.2
  AW_COPY procedure, 24.4.2
  AW_CREATE procedure, 24.4.2
  AW_DELETE procedure, 24.4.2
  AW_DETACH procedure, 24.4.2
  AW_RENAME procedure, 24.4.2
  AW_TABLESPACE function, 24.4.2
  AW_UPDATE procedure, 24.4.2
  AWXML
    see OLAP Analytic Workspace Java API
  AWXML.xsd, 25.2
  AWXML.xsd schema, 25.2

## C

  caches
    performance statistics, 6.5
  composite specifications, 1.2, 4.1, 4.3, 4.11, 26.1
    DBMS_AWM methods on, 1.2.6
  composites, 1.5, 26.1
  composites (regular and compressed)
    defined, 24.3.1
  CONVERT procedure, 24.4.2
  cube load specifications, 1.1.3, 1.2, 4.10, 4.10, 26.1
    DBMS_AWM methods on, 1.2.4
  cubes, 1.2
    creating, 2.4.1, 7.1, 9, 9.1
    creating in analytic workspaces, 1.1.3, 26.1
    DBMS_AWM methods on, 1.2.2
    in analytic workspaces, 3.7
    naming in analytic workspaces, 26.1
    populating in analytic workspaces, 26.1
    source, 26.1
    target, 26.1
    valid, 22.1.1.1
    viewing, 5.8
  custom measures, 30.1.1, 32.1.1, 33.1.1
    creating with OLAP Analytic Workspace Java API, 25.1
    examples with OLAP_EXPRESSION, 30.2
  CWM2, 1.1.1, 2
    directing output, 2.8
    read APIs, 2.9
    write APIs, 2
  CWM2_OLAP_CATALOG package, 7
  CWM2_OLAP_CLASSIFY package, 8
  CWM2_OLAP_CUBE package, 9
  CWM2_OLAP_DELETE package, 10
  CWM2_OLAP_DIMENSION package, 11
  CWM2_OLAP_DIMENSION_ATTRIBUTE package, 12
  CWM2_OLAP_EXPORT package, 13
  CWM2_OLAP_HIERARCHY package, 14
  CWM2_OLAP_LEVEL package, 15
  CWM2_OLAP_LEVEL_ATTRIBUTE package, 16
  CWM2_OLAP_MANAGER package, 1.3, 1.4, 2.6.1, 2.8, 17
  CWM2_OLAP_MEASURE package, 18
  CWM2_OLAP_METADATA_REFRESH package, 19
  CWM2_OLAP_PC_TRANSFORM package, 20
  CWM2_OLAP_TABLE_MAP package, 21
  CWM2_OLAP_VALIDATE package, 22
  CWM2_OLAP_VERIFY_ACCESS package, 23

## D

  data type conversions, 1.4, 34.1.4
  database cache, 6.5
  database initialization, 28, 28.1
  database standard form, 3.1, 24.2, 26.1, 34.1
    see also analytic workspaces
    version, 3.5
    views of, 3
  DBMS_AW
    SPARSITY_ADVICE_TABLE procedure, 24.4.2
  DBMS_AW package, 24, 34.1
    ADD_DIMENSION_SOURCE procedure, 24.4.2
    ADVISE_CUBE procedure, 24.4.2
    ADVISE_DIMENSIONALITY function, 24.4.2
    ADVISE_DIMENSIONALITY procedure, 24.4.2
    ADVISE_REL procedure, 24.4.2
    ADVISE_SPARSITY procedure, 24.4.2
    AW_ATTACH procedure, 24.4.2
    AW_COPY procedure, 24.4.2
    AW_CREATE procedure, 24.4.2
    AW_DELETE procedure, 24.4.2
    AW_DETACH procedure, 24.4.2
    AW_RENAME procedure, 24.4.2
    AW_TABLESPACE function, 24.4.2
    AW_UPDATE procedure, 24.4.2
    CONVERT procedure, 24.4.2
    EVAL_NUMBER function, 24.4.2
    EVAL_TEXT function, 24.4.2
    EXECUTE procedure, 24.4.2
    GETLOG function, 24.4.2
    INFILE procedure, 24.4.2
    INTERP function, 24.4.2
    INTERP_SILENT function, 24.4.2
    INTERPCLOB function, 24.4.2
    OLAP_ON function, 24.4.2, 24.4.2
    PRINTLOG procedure, 24.4.2
    RUN procedure, 24.4.2
    SHUTDOWN procedure, 24.4.2
    STARTUP procedure, 24.4.2
  DBMS_AW$_COLUMNLIST_T table, 24.3.2
  DBMS_AW$_DIMENSION_SOURCE_T object type, 24.3.2
  DBMS_AW$_DIMENSION_SOURCES_T table type, 24.3.2
  DBMS_AW_XML package, 25
  DBMS_AWM package, 1, 3, 26
  DBMS_ODM package, 27
  dimension alias, 5.9
  dimension attributes
    creating, 12
    reserved, 12.1
    viewing, 5.14
  dimension load specifications, 1.1.2, 1.2, 26.1, 26.1
    DBMS_AWM methods on, 1.2.3
  dimension tables, 2.5
    defining OLAP Catalog metadata for, 2.3
  dimension views
    defining for workspace objects, 1.8.7, 26.1
  dimensions, 1.2
    creating, 2.3, 11
    creating in analytic workspaces, 1.1.2, 26.1
    DBMS_AWM methods on, 1.2.1
    embedded-total, 20.4.2
    in analytic workspaces, 3.12, 3.14, 3.15
    naming in analytic workspaces, 26.1
    ordering in analytic workspaces, 1.1.3, 1.5
    parent-child, 20
    populating in analytic workspaces, 26.1
    valid, 22.1.1.2
    viewing, 5.13
  directory object, 1.8.1, 2.8, 17.2, 20.1, 20.4.2, 26.1, 26.1, 26.1, 26.1, 27.3, 27.3, 27.3
  DISPLAY_NAME, 4.17, 26.1
  dynamic performance views, 6

## E

  embedded-total cubes, 22.1.3
  embedded-total dimension views, 1.8, 1.8.7, 34.2.1
  embedded-total fact tables, 2.5.2
  embedded-total fact view, 1.8, 34.2.2
  embedded-total key, 2.5.2, 22.1.3
  enabling for relational access, 1.1.5, 1.8
    See Also analytic workspaces
      enabling for SQL access
  End Date, 12.1, 16.1
  end-date attribute, 22.1.3
  ET Key, 12.1, 16.1
  EVAL_NUMBER function, 24.4.2
  EVAL_TEXT function, 24.4.2
  EXECUTE procedure, 24.4.2

## F

  fact tables, 2.5, 5.24
    defining OLAP Catalog metadata for, 2.4
    joining with dimension tables, 2.5.2
    supported configurations, 2.5.2
  fact views
    defining from workspace objects, 1.8.8, 26.1, 26.1, 26.1, 26.1, 26.1
  FETCH command (OLAP DML), 34.2.4, 34.2.4
  fixed views, 6.1

## G

  GETLOG function, 24.4.2
  grouping IDs, 1.8.7, 1.8.7.2, 2.5.2, 5.25, 12.1, 16.1, 20.4.1, 22.1.3
    parent, 1.8.7

## H

  hierarchies
    creating, 14
    custom sorting, 5.26, 21.3
    defined, 14.1
    viewing, 5.16, 5.17, 5.27

## I

  INFILE procedure, 24.4.2
  initialization parameters, 28, 28.1
  init.ora file, 28.1
  INTERACTIONEXECUTE function
    see DBMS_AW_XML package
  INTERP function, 24.4.2
  INTERP_SILENT procedure, 24.4.2
  INTERPCLOB function, 24.4.2

## J

  Java API
    Analytic Workspace, 25.1

## L

  level attributes
    creating, 16
    defined, 16.1
    reserved, 16.1
    viewing, 5.19, 5.20
  levels
    creating, 15
    in analytic workspaces, 3.8, 3.16
    viewing, 5.18
  limit maps, 34.1.1, 34.2.4, 34.2.4
    order of processing, 34.2.4
    syntax, 34.2.4
  Long Description, 12.1, 16.1

## M

  materialized views
    for OLAP API, 27
  measure folders
    creating, 7
    defined, 5.6, 7.1
    viewing, 5.7
  measures
    creating, 18
    defined, 18.1
    in analytic workspaces, 3.9, 3.13
    viewing, 5.10
  metadata descriptors, 8
  Metadata Reader tables
    refreshing, 2.6, 2.6.3, 2.9
  metadata upgrade, 26.1
  MR_REFRESH procedure, 19.2
  MRV_OLAP views, 2.6.3, 2.9, 19.1, 19.2
  multidimensional data
    enabling for SQL access, 1.7, 26, 26.1, 26.1, 26.1, 26.1, 26.1, 26.1
  multidimensional data model
    Active Catalog, 3
    database standard form, 3
  multidimensional target cube, 1.1

## O

  object types
    automatic, 34.1.3
    predefining, 34.1.3
    syntax for creating, 34.1.2
  OLADM, 24.4.2
  OLAP Analytic Workspace Java API, 2.1, 3, 4.18, 4.19, 34.1
  OLAP API, 34.1
    Metadata Reader tables, 2.6.3, 2.9
    optimization, 28
  OLAP Catalog, 2.6.3, 19.1
    exporting, 13
    metadata entities, 2.2
    metadata entity size, 2.2
    metadata entity size limitations, 2.7.2
    overview, 2.1, 3.1
    preprocessors, 20
    read APIs, 2.9, 4, 5, 19
    viewing, 2.9, 5, 19
    write APIs, 2
  OLAP Catalog metadata
    committing, 2.6
    creating for a dimension table, 2.3.2
    creating for a fact table, 2.4.2
    creating for DBMS_AWM, 1.1.1, 2.1
    creating for the OLAP API, 2.1
    deleting, 10
    exporting, 13
    mapping, 2.3.2, 2.3.4, 2.5, 5.11, 5.20, 5.28, 21.1, 22.1.2
    mapping to embedded-total tables, 2.1, 2.5.2
    mapping to star and snowflake schemas, 2.1, 2.5.2
    validating, 2.6, 22, 23
  OLAP DML
    executing in SQL, 24, 29, 30, 31, 32, 33
    quotation marks in, 24.2.2
  OLAP performance views, 6.1
  OLAP XML schema, 25.2
  OLAP_API_SESSION_INIT package, 28
  OLAP_CONDITION function, 29, 34.2.4
  OLAP_EXPRESSION function, 24.2.1, 30
  OLAP_EXPRESSION_BOOL function, 31
  OLAP_EXPRESSION_DATE function, 32
  OLAP_EXPRESSION_TEXT function, 33
  OLAP_ON function, 24.4.2, 24.4.2
  OLAP_PAGE_POOL_SIZE parameter, 6.5
  OLAP_TABLE function, 34
    custom measures, 30.2
    data map parameter, 34.2.4
    data type conversions, 34.1.4
    examples, 34.2
    FETCH command, 34.2.4, 34.2.4
    limit map, 34.1.1, 34.2.4, 34.2.4
    retrieving session log, 24.4.2
    specifying a ROW2CELL column, 34.2.4
    specifying an OLAP DML command, 34.2.4, 34.2.4, 34.2.4, 34.2.4
    specifying the analytic workspace, 34.2.4, 34.2.4
    specifying the limit map, 34.2.4
    specifying the logical table, 34.2.4, 34.2.4
    with MODEL clause, 34.1.5
  optimization
    OLAP API, 28, 28.1
    OLAP_TABLE, 34.1.5
  Oracle Enterprise Manager, 1.1.1
  Oracle Warehouse Builder, 1.1.1
  OUTFILE command
    affect on DBMS_AW.EXECUTE, 24.4.2
    affect on DBMS_AW.RUN, 24.4.2

## P

  P_DISPLAY_NAME, 4.17, 26.1
  page pool
    performance statistics, 6.5
  Parent ET Key, 12.1, 16.1
  Parent Grouping ID, 12.1, 16.1
  performance counters, 6
  PGA allocation, 6.5
  print buffer, 24.4.2, 24.4.2
  PRINTLOG procedure, 24.4.2
  Prior Period, 12.1, 16.1
  properties
    obtaining in SQL, 4.19

## Q

  quotation marks
    in OLAP DML, 24.2.2

## R

  refreshing the cache, 2.6.3, 3.2, 19.1, 19.2
  relational source cube, 1.1
  relational target cube, 1.1
  reserved dimension attributes, 12.1
  reserved level attributes, 16.1
  ROW2CELL column, 29.1.1, 29.2, 30.1.2, 31.1.2, 32.1.2, 34.2.4
  RUN procedure, 24.4.2

## S

  segwidth, 26.1
  SERVEROUTPUT option, 1.3, 1.4, 2.6.1, 2.8, 2.8, 17.1, 24.4.2, 24.4.2, 24.4.2
  session
    shutting down, 24.4.2
    starting up, 24.4.2
  session cache
    performance statistics, 6.5
  session counters, 6.8
  session logs
    printing, 24.4.2
    retrieving, 24.4.2
  session statistics, 6.7
  Short Description, 12.1, 16.1
  SHUTDOWN procedure, 24.4.2
  single-row functions, 30.1.1, 31.1.1, 32.1.1, 33.1.1
  snowflake schema, 2.5.1.1
  solved data, 1.1, 1.8.7, 1.8.8, 2.5.2
  solved_code, 2.5.2, 5.16, 14.2
  sparse data, 1.5, 26.1
  Sparsity Advisor, 24.3
  SPARSITY_ADVICE_TABLE column descriptions, 24.4.2
  SPARSITY_ADVICE_TABLE procedure, 24.4.2
  SQL
    embedding OLAP commands, 24, 29, 30, 31, 32, 33
    managing analytic workspaces, 24
  standard form
    see database standard form
  star schema, 2.5.1.1
  STARTUP procedure, 24.4.2

## T

  table type, 34.2.4, 34.2.4
    automatic, 34.1.3
    predefining, 34.1.3
    syntax for creating, 34.1.2
  time dimensions
    creating, 2.3.3
  Time Span, 12.1, 16.1
  time-span attribute, 22.1.3
  transaction statistics, 6.8
  tuples, 24.3.1

## U

  UNIQUE_RDBMS_KEY, 4.17, 26.1
  unsolved data, 1.1, 2.5.2
  upgrading, 26.1
  UTL_FILE_DIR parameter, 1.8.1, 2.8, 17.2, 20.1, 20.4.2, 26.1, 26.1, 26.1, 26.1, 27.3, 27.3, 27.3

## V

  V$AW_AGGREGATE_OP view, 6.3
  V$AW_ALLOCATE_OP view, 6.4
  V$AW_CALC view, 6.5
  V$AW_OLAP view, 6.7
  V$AW_SESSION_INFO view, 6.8
  validating OLAP Catalog metadata, 2.6
  views
    Active Catalog, 3
    analytic workspace maintenance information, 4
    creating embedded total dimensions, 1.8.7, 34.2.1
    creating embedded total measures, 34.2.2
    creating for analytic workspaces, 1.8
    creating rollup form, 34.2.3
    objects in analytic workspaces, 3
    OLAP Catalog metadata, 5
    template for creating with OLAP_TABLE, 34.1.3, 34.1.4

## W

  workspace objects
    obtaining names in SQL, 4.18

## X

  XML document
    example, 25.2

## Y

  Year Ago Period, 12.1, 16.1